package com.ecoolex.chinadutyfree.retailer.entity;

import com.ecoolex.framework.common.annotation.Description;
import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;
import org.springframework.lang.NonNull;

public class DirectMailGoodsOrderIncrementDataExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    protected Integer offset;

    protected Integer rows;

    public DirectMailGoodsOrderIncrementDataExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public DirectMailGoodsOrderIncrementDataExample orderBy(String orderByClause) {
        this.setOrderByClause(orderByClause);
        return this;
    }

    public DirectMailGoodsOrderIncrementDataExample orderBy(String ... orderByClauses) {
        StringBuffer sb = new StringBuffer();
        for (int i = 0; i < orderByClauses.length; i++) {
            sb.append(orderByClauses[i]);
            if (i < orderByClauses.length - 1) {
                sb.append(" , ");
            }
        }
        this.setOrderByClause(sb.toString());
        return this;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria(this);
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
        rows = null;
        offset = null;
    }

    public static Criteria newAndCreateCriteria() {
        DirectMailGoodsOrderIncrementDataExample example = new DirectMailGoodsOrderIncrementDataExample();
        return example.createCriteria();
    }

    public DirectMailGoodsOrderIncrementDataExample when(boolean condition, IExampleWhen then) {
        if (condition) {
            then.example(this);
        }
        return this;
    }

    public DirectMailGoodsOrderIncrementDataExample when(boolean condition, IExampleWhen then, IExampleWhen otherwise) {
        if (condition) {
            then.example(this);
        } else {
            otherwise.example(this);
        }
        return this;
    }

    public void setOffset(Integer offset) {
        this.offset = offset;
    }

    public Integer getOffset() {
        return this.offset;
    }

    public void setRows(Integer rows) {
        this.rows = rows;
    }

    public Integer getRows() {
        return this.rows;
    }

    public DirectMailGoodsOrderIncrementDataExample limit(Integer rows) {
        this.rows = rows;
        return this;
    }

    public DirectMailGoodsOrderIncrementDataExample limit(Integer offset, Integer rows) {
        this.offset = offset;
        this.rows = rows;
        return this;
    }

    public DirectMailGoodsOrderIncrementDataExample page(Integer page, Integer pageSize) {
        this.offset = page * pageSize;
        this.rows = pageSize;
        return this;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andIdIsNull() {
            addCriterion("directmailgoodsorderincrementdata.Id is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("directmailgoodsorderincrementdata.Id is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(Integer value) {
            addCriterion("directmailgoodsorderincrementdata.Id =", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdEqualToColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.Id = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(Integer value) {
            addCriterion("directmailgoodsorderincrementdata.Id <>", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotEqualToColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.Id <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(Integer value) {
            addCriterion("directmailgoodsorderincrementdata.Id >", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.Id > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("directmailgoodsorderincrementdata.Id >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualToColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.Id >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andIdLessThan(Integer value) {
            addCriterion("directmailgoodsorderincrementdata.Id <", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.Id < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(Integer value) {
            addCriterion("directmailgoodsorderincrementdata.Id <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualToColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.Id <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andIdIn(List<Integer> values) {
            addCriterion("directmailgoodsorderincrementdata.Id in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<Integer> values) {
            addCriterion("directmailgoodsorderincrementdata.Id not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdBetween(Integer value1, Integer value2) {
            addCriterion("directmailgoodsorderincrementdata.Id between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(Integer value1, Integer value2) {
            addCriterion("directmailgoodsorderincrementdata.Id not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andNewTotalNumberIsNull() {
            addCriterion("directmailgoodsorderincrementdata.NewTotalNumber is null");
            return (Criteria) this;
        }

        public Criteria andNewTotalNumberIsNotNull() {
            addCriterion("directmailgoodsorderincrementdata.NewTotalNumber is not null");
            return (Criteria) this;
        }

        public Criteria andNewTotalNumberEqualTo(Integer value) {
            addCriterion("directmailgoodsorderincrementdata.NewTotalNumber =", value, "newTotalNumber");
            return (Criteria) this;
        }

        public Criteria andNewTotalNumberEqualToColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.NewTotalNumber = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNewTotalNumberNotEqualTo(Integer value) {
            addCriterion("directmailgoodsorderincrementdata.NewTotalNumber <>", value, "newTotalNumber");
            return (Criteria) this;
        }

        public Criteria andNewTotalNumberNotEqualToColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.NewTotalNumber <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNewTotalNumberGreaterThan(Integer value) {
            addCriterion("directmailgoodsorderincrementdata.NewTotalNumber >", value, "newTotalNumber");
            return (Criteria) this;
        }

        public Criteria andNewTotalNumberGreaterThanColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.NewTotalNumber > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNewTotalNumberGreaterThanOrEqualTo(Integer value) {
            addCriterion("directmailgoodsorderincrementdata.NewTotalNumber >=", value, "newTotalNumber");
            return (Criteria) this;
        }

        public Criteria andNewTotalNumberGreaterThanOrEqualToColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.NewTotalNumber >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNewTotalNumberLessThan(Integer value) {
            addCriterion("directmailgoodsorderincrementdata.NewTotalNumber <", value, "newTotalNumber");
            return (Criteria) this;
        }

        public Criteria andNewTotalNumberLessThanColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.NewTotalNumber < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNewTotalNumberLessThanOrEqualTo(Integer value) {
            addCriterion("directmailgoodsorderincrementdata.NewTotalNumber <=", value, "newTotalNumber");
            return (Criteria) this;
        }

        public Criteria andNewTotalNumberLessThanOrEqualToColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.NewTotalNumber <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNewTotalNumberIn(List<Integer> values) {
            addCriterion("directmailgoodsorderincrementdata.NewTotalNumber in", values, "newTotalNumber");
            return (Criteria) this;
        }

        public Criteria andNewTotalNumberNotIn(List<Integer> values) {
            addCriterion("directmailgoodsorderincrementdata.NewTotalNumber not in", values, "newTotalNumber");
            return (Criteria) this;
        }

        public Criteria andNewTotalNumberBetween(Integer value1, Integer value2) {
            addCriterion("directmailgoodsorderincrementdata.NewTotalNumber between", value1, value2, "newTotalNumber");
            return (Criteria) this;
        }

        public Criteria andNewTotalNumberNotBetween(Integer value1, Integer value2) {
            addCriterion("directmailgoodsorderincrementdata.NewTotalNumber not between", value1, value2, "newTotalNumber");
            return (Criteria) this;
        }

        public Criteria andNewPaidNumberIsNull() {
            addCriterion("directmailgoodsorderincrementdata.NewPaidNumber is null");
            return (Criteria) this;
        }

        public Criteria andNewPaidNumberIsNotNull() {
            addCriterion("directmailgoodsorderincrementdata.NewPaidNumber is not null");
            return (Criteria) this;
        }

        public Criteria andNewPaidNumberEqualTo(Integer value) {
            addCriterion("directmailgoodsorderincrementdata.NewPaidNumber =", value, "newPaidNumber");
            return (Criteria) this;
        }

        public Criteria andNewPaidNumberEqualToColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.NewPaidNumber = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNewPaidNumberNotEqualTo(Integer value) {
            addCriterion("directmailgoodsorderincrementdata.NewPaidNumber <>", value, "newPaidNumber");
            return (Criteria) this;
        }

        public Criteria andNewPaidNumberNotEqualToColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.NewPaidNumber <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNewPaidNumberGreaterThan(Integer value) {
            addCriterion("directmailgoodsorderincrementdata.NewPaidNumber >", value, "newPaidNumber");
            return (Criteria) this;
        }

        public Criteria andNewPaidNumberGreaterThanColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.NewPaidNumber > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNewPaidNumberGreaterThanOrEqualTo(Integer value) {
            addCriterion("directmailgoodsorderincrementdata.NewPaidNumber >=", value, "newPaidNumber");
            return (Criteria) this;
        }

        public Criteria andNewPaidNumberGreaterThanOrEqualToColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.NewPaidNumber >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNewPaidNumberLessThan(Integer value) {
            addCriterion("directmailgoodsorderincrementdata.NewPaidNumber <", value, "newPaidNumber");
            return (Criteria) this;
        }

        public Criteria andNewPaidNumberLessThanColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.NewPaidNumber < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNewPaidNumberLessThanOrEqualTo(Integer value) {
            addCriterion("directmailgoodsorderincrementdata.NewPaidNumber <=", value, "newPaidNumber");
            return (Criteria) this;
        }

        public Criteria andNewPaidNumberLessThanOrEqualToColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.NewPaidNumber <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNewPaidNumberIn(List<Integer> values) {
            addCriterion("directmailgoodsorderincrementdata.NewPaidNumber in", values, "newPaidNumber");
            return (Criteria) this;
        }

        public Criteria andNewPaidNumberNotIn(List<Integer> values) {
            addCriterion("directmailgoodsorderincrementdata.NewPaidNumber not in", values, "newPaidNumber");
            return (Criteria) this;
        }

        public Criteria andNewPaidNumberBetween(Integer value1, Integer value2) {
            addCriterion("directmailgoodsorderincrementdata.NewPaidNumber between", value1, value2, "newPaidNumber");
            return (Criteria) this;
        }

        public Criteria andNewPaidNumberNotBetween(Integer value1, Integer value2) {
            addCriterion("directmailgoodsorderincrementdata.NewPaidNumber not between", value1, value2, "newPaidNumber");
            return (Criteria) this;
        }

        public Criteria andNewConfirmNumberIsNull() {
            addCriterion("directmailgoodsorderincrementdata.NewConfirmNumber is null");
            return (Criteria) this;
        }

        public Criteria andNewConfirmNumberIsNotNull() {
            addCriterion("directmailgoodsorderincrementdata.NewConfirmNumber is not null");
            return (Criteria) this;
        }

        public Criteria andNewConfirmNumberEqualTo(Integer value) {
            addCriterion("directmailgoodsorderincrementdata.NewConfirmNumber =", value, "newConfirmNumber");
            return (Criteria) this;
        }

        public Criteria andNewConfirmNumberEqualToColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.NewConfirmNumber = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNewConfirmNumberNotEqualTo(Integer value) {
            addCriterion("directmailgoodsorderincrementdata.NewConfirmNumber <>", value, "newConfirmNumber");
            return (Criteria) this;
        }

        public Criteria andNewConfirmNumberNotEqualToColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.NewConfirmNumber <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNewConfirmNumberGreaterThan(Integer value) {
            addCriterion("directmailgoodsorderincrementdata.NewConfirmNumber >", value, "newConfirmNumber");
            return (Criteria) this;
        }

        public Criteria andNewConfirmNumberGreaterThanColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.NewConfirmNumber > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNewConfirmNumberGreaterThanOrEqualTo(Integer value) {
            addCriterion("directmailgoodsorderincrementdata.NewConfirmNumber >=", value, "newConfirmNumber");
            return (Criteria) this;
        }

        public Criteria andNewConfirmNumberGreaterThanOrEqualToColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.NewConfirmNumber >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNewConfirmNumberLessThan(Integer value) {
            addCriterion("directmailgoodsorderincrementdata.NewConfirmNumber <", value, "newConfirmNumber");
            return (Criteria) this;
        }

        public Criteria andNewConfirmNumberLessThanColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.NewConfirmNumber < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNewConfirmNumberLessThanOrEqualTo(Integer value) {
            addCriterion("directmailgoodsorderincrementdata.NewConfirmNumber <=", value, "newConfirmNumber");
            return (Criteria) this;
        }

        public Criteria andNewConfirmNumberLessThanOrEqualToColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.NewConfirmNumber <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNewConfirmNumberIn(List<Integer> values) {
            addCriterion("directmailgoodsorderincrementdata.NewConfirmNumber in", values, "newConfirmNumber");
            return (Criteria) this;
        }

        public Criteria andNewConfirmNumberNotIn(List<Integer> values) {
            addCriterion("directmailgoodsorderincrementdata.NewConfirmNumber not in", values, "newConfirmNumber");
            return (Criteria) this;
        }

        public Criteria andNewConfirmNumberBetween(Integer value1, Integer value2) {
            addCriterion("directmailgoodsorderincrementdata.NewConfirmNumber between", value1, value2, "newConfirmNumber");
            return (Criteria) this;
        }

        public Criteria andNewConfirmNumberNotBetween(Integer value1, Integer value2) {
            addCriterion("directmailgoodsorderincrementdata.NewConfirmNumber not between", value1, value2, "newConfirmNumber");
            return (Criteria) this;
        }

        public Criteria andNewAfterSalesNumberIsNull() {
            addCriterion("directmailgoodsorderincrementdata.NewAfterSalesNumber is null");
            return (Criteria) this;
        }

        public Criteria andNewAfterSalesNumberIsNotNull() {
            addCriterion("directmailgoodsorderincrementdata.NewAfterSalesNumber is not null");
            return (Criteria) this;
        }

        public Criteria andNewAfterSalesNumberEqualTo(Integer value) {
            addCriterion("directmailgoodsorderincrementdata.NewAfterSalesNumber =", value, "newAfterSalesNumber");
            return (Criteria) this;
        }

        public Criteria andNewAfterSalesNumberEqualToColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.NewAfterSalesNumber = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNewAfterSalesNumberNotEqualTo(Integer value) {
            addCriterion("directmailgoodsorderincrementdata.NewAfterSalesNumber <>", value, "newAfterSalesNumber");
            return (Criteria) this;
        }

        public Criteria andNewAfterSalesNumberNotEqualToColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.NewAfterSalesNumber <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNewAfterSalesNumberGreaterThan(Integer value) {
            addCriterion("directmailgoodsorderincrementdata.NewAfterSalesNumber >", value, "newAfterSalesNumber");
            return (Criteria) this;
        }

        public Criteria andNewAfterSalesNumberGreaterThanColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.NewAfterSalesNumber > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNewAfterSalesNumberGreaterThanOrEqualTo(Integer value) {
            addCriterion("directmailgoodsorderincrementdata.NewAfterSalesNumber >=", value, "newAfterSalesNumber");
            return (Criteria) this;
        }

        public Criteria andNewAfterSalesNumberGreaterThanOrEqualToColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.NewAfterSalesNumber >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNewAfterSalesNumberLessThan(Integer value) {
            addCriterion("directmailgoodsorderincrementdata.NewAfterSalesNumber <", value, "newAfterSalesNumber");
            return (Criteria) this;
        }

        public Criteria andNewAfterSalesNumberLessThanColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.NewAfterSalesNumber < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNewAfterSalesNumberLessThanOrEqualTo(Integer value) {
            addCriterion("directmailgoodsorderincrementdata.NewAfterSalesNumber <=", value, "newAfterSalesNumber");
            return (Criteria) this;
        }

        public Criteria andNewAfterSalesNumberLessThanOrEqualToColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.NewAfterSalesNumber <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNewAfterSalesNumberIn(List<Integer> values) {
            addCriterion("directmailgoodsorderincrementdata.NewAfterSalesNumber in", values, "newAfterSalesNumber");
            return (Criteria) this;
        }

        public Criteria andNewAfterSalesNumberNotIn(List<Integer> values) {
            addCriterion("directmailgoodsorderincrementdata.NewAfterSalesNumber not in", values, "newAfterSalesNumber");
            return (Criteria) this;
        }

        public Criteria andNewAfterSalesNumberBetween(Integer value1, Integer value2) {
            addCriterion("directmailgoodsorderincrementdata.NewAfterSalesNumber between", value1, value2, "newAfterSalesNumber");
            return (Criteria) this;
        }

        public Criteria andNewAfterSalesNumberNotBetween(Integer value1, Integer value2) {
            addCriterion("directmailgoodsorderincrementdata.NewAfterSalesNumber not between", value1, value2, "newAfterSalesNumber");
            return (Criteria) this;
        }

        public Criteria andNewCloseNumberIsNull() {
            addCriterion("directmailgoodsorderincrementdata.NewCloseNumber is null");
            return (Criteria) this;
        }

        public Criteria andNewCloseNumberIsNotNull() {
            addCriterion("directmailgoodsorderincrementdata.NewCloseNumber is not null");
            return (Criteria) this;
        }

        public Criteria andNewCloseNumberEqualTo(Integer value) {
            addCriterion("directmailgoodsorderincrementdata.NewCloseNumber =", value, "newCloseNumber");
            return (Criteria) this;
        }

        public Criteria andNewCloseNumberEqualToColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.NewCloseNumber = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNewCloseNumberNotEqualTo(Integer value) {
            addCriterion("directmailgoodsorderincrementdata.NewCloseNumber <>", value, "newCloseNumber");
            return (Criteria) this;
        }

        public Criteria andNewCloseNumberNotEqualToColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.NewCloseNumber <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNewCloseNumberGreaterThan(Integer value) {
            addCriterion("directmailgoodsorderincrementdata.NewCloseNumber >", value, "newCloseNumber");
            return (Criteria) this;
        }

        public Criteria andNewCloseNumberGreaterThanColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.NewCloseNumber > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNewCloseNumberGreaterThanOrEqualTo(Integer value) {
            addCriterion("directmailgoodsorderincrementdata.NewCloseNumber >=", value, "newCloseNumber");
            return (Criteria) this;
        }

        public Criteria andNewCloseNumberGreaterThanOrEqualToColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.NewCloseNumber >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNewCloseNumberLessThan(Integer value) {
            addCriterion("directmailgoodsorderincrementdata.NewCloseNumber <", value, "newCloseNumber");
            return (Criteria) this;
        }

        public Criteria andNewCloseNumberLessThanColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.NewCloseNumber < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNewCloseNumberLessThanOrEqualTo(Integer value) {
            addCriterion("directmailgoodsorderincrementdata.NewCloseNumber <=", value, "newCloseNumber");
            return (Criteria) this;
        }

        public Criteria andNewCloseNumberLessThanOrEqualToColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.NewCloseNumber <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNewCloseNumberIn(List<Integer> values) {
            addCriterion("directmailgoodsorderincrementdata.NewCloseNumber in", values, "newCloseNumber");
            return (Criteria) this;
        }

        public Criteria andNewCloseNumberNotIn(List<Integer> values) {
            addCriterion("directmailgoodsorderincrementdata.NewCloseNumber not in", values, "newCloseNumber");
            return (Criteria) this;
        }

        public Criteria andNewCloseNumberBetween(Integer value1, Integer value2) {
            addCriterion("directmailgoodsorderincrementdata.NewCloseNumber between", value1, value2, "newCloseNumber");
            return (Criteria) this;
        }

        public Criteria andNewCloseNumberNotBetween(Integer value1, Integer value2) {
            addCriterion("directmailgoodsorderincrementdata.NewCloseNumber not between", value1, value2, "newCloseNumber");
            return (Criteria) this;
        }

        public Criteria andNewSuccessNumberIsNull() {
            addCriterion("directmailgoodsorderincrementdata.NewSuccessNumber is null");
            return (Criteria) this;
        }

        public Criteria andNewSuccessNumberIsNotNull() {
            addCriterion("directmailgoodsorderincrementdata.NewSuccessNumber is not null");
            return (Criteria) this;
        }

        public Criteria andNewSuccessNumberEqualTo(Integer value) {
            addCriterion("directmailgoodsorderincrementdata.NewSuccessNumber =", value, "newSuccessNumber");
            return (Criteria) this;
        }

        public Criteria andNewSuccessNumberEqualToColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.NewSuccessNumber = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNewSuccessNumberNotEqualTo(Integer value) {
            addCriterion("directmailgoodsorderincrementdata.NewSuccessNumber <>", value, "newSuccessNumber");
            return (Criteria) this;
        }

        public Criteria andNewSuccessNumberNotEqualToColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.NewSuccessNumber <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNewSuccessNumberGreaterThan(Integer value) {
            addCriterion("directmailgoodsorderincrementdata.NewSuccessNumber >", value, "newSuccessNumber");
            return (Criteria) this;
        }

        public Criteria andNewSuccessNumberGreaterThanColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.NewSuccessNumber > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNewSuccessNumberGreaterThanOrEqualTo(Integer value) {
            addCriterion("directmailgoodsorderincrementdata.NewSuccessNumber >=", value, "newSuccessNumber");
            return (Criteria) this;
        }

        public Criteria andNewSuccessNumberGreaterThanOrEqualToColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.NewSuccessNumber >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNewSuccessNumberLessThan(Integer value) {
            addCriterion("directmailgoodsorderincrementdata.NewSuccessNumber <", value, "newSuccessNumber");
            return (Criteria) this;
        }

        public Criteria andNewSuccessNumberLessThanColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.NewSuccessNumber < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNewSuccessNumberLessThanOrEqualTo(Integer value) {
            addCriterion("directmailgoodsorderincrementdata.NewSuccessNumber <=", value, "newSuccessNumber");
            return (Criteria) this;
        }

        public Criteria andNewSuccessNumberLessThanOrEqualToColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.NewSuccessNumber <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNewSuccessNumberIn(List<Integer> values) {
            addCriterion("directmailgoodsorderincrementdata.NewSuccessNumber in", values, "newSuccessNumber");
            return (Criteria) this;
        }

        public Criteria andNewSuccessNumberNotIn(List<Integer> values) {
            addCriterion("directmailgoodsorderincrementdata.NewSuccessNumber not in", values, "newSuccessNumber");
            return (Criteria) this;
        }

        public Criteria andNewSuccessNumberBetween(Integer value1, Integer value2) {
            addCriterion("directmailgoodsorderincrementdata.NewSuccessNumber between", value1, value2, "newSuccessNumber");
            return (Criteria) this;
        }

        public Criteria andNewSuccessNumberNotBetween(Integer value1, Integer value2) {
            addCriterion("directmailgoodsorderincrementdata.NewSuccessNumber not between", value1, value2, "newSuccessNumber");
            return (Criteria) this;
        }

        public Criteria andNewTotalPriceIsNull() {
            addCriterion("directmailgoodsorderincrementdata.NewTotalPrice is null");
            return (Criteria) this;
        }

        public Criteria andNewTotalPriceIsNotNull() {
            addCriterion("directmailgoodsorderincrementdata.NewTotalPrice is not null");
            return (Criteria) this;
        }

        public Criteria andNewTotalPriceEqualTo(BigDecimal value) {
            addCriterion("directmailgoodsorderincrementdata.NewTotalPrice =", value, "newTotalPrice");
            return (Criteria) this;
        }

        public Criteria andNewTotalPriceEqualToColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.NewTotalPrice = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNewTotalPriceNotEqualTo(BigDecimal value) {
            addCriterion("directmailgoodsorderincrementdata.NewTotalPrice <>", value, "newTotalPrice");
            return (Criteria) this;
        }

        public Criteria andNewTotalPriceNotEqualToColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.NewTotalPrice <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNewTotalPriceGreaterThan(BigDecimal value) {
            addCriterion("directmailgoodsorderincrementdata.NewTotalPrice >", value, "newTotalPrice");
            return (Criteria) this;
        }

        public Criteria andNewTotalPriceGreaterThanColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.NewTotalPrice > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNewTotalPriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("directmailgoodsorderincrementdata.NewTotalPrice >=", value, "newTotalPrice");
            return (Criteria) this;
        }

        public Criteria andNewTotalPriceGreaterThanOrEqualToColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.NewTotalPrice >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNewTotalPriceLessThan(BigDecimal value) {
            addCriterion("directmailgoodsorderincrementdata.NewTotalPrice <", value, "newTotalPrice");
            return (Criteria) this;
        }

        public Criteria andNewTotalPriceLessThanColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.NewTotalPrice < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNewTotalPriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("directmailgoodsorderincrementdata.NewTotalPrice <=", value, "newTotalPrice");
            return (Criteria) this;
        }

        public Criteria andNewTotalPriceLessThanOrEqualToColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.NewTotalPrice <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNewTotalPriceIn(List<BigDecimal> values) {
            addCriterion("directmailgoodsorderincrementdata.NewTotalPrice in", values, "newTotalPrice");
            return (Criteria) this;
        }

        public Criteria andNewTotalPriceNotIn(List<BigDecimal> values) {
            addCriterion("directmailgoodsorderincrementdata.NewTotalPrice not in", values, "newTotalPrice");
            return (Criteria) this;
        }

        public Criteria andNewTotalPriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("directmailgoodsorderincrementdata.NewTotalPrice between", value1, value2, "newTotalPrice");
            return (Criteria) this;
        }

        public Criteria andNewTotalPriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("directmailgoodsorderincrementdata.NewTotalPrice not between", value1, value2, "newTotalPrice");
            return (Criteria) this;
        }

        public Criteria andNewPaidPriceIsNull() {
            addCriterion("directmailgoodsorderincrementdata.NewPaidPrice is null");
            return (Criteria) this;
        }

        public Criteria andNewPaidPriceIsNotNull() {
            addCriterion("directmailgoodsorderincrementdata.NewPaidPrice is not null");
            return (Criteria) this;
        }

        public Criteria andNewPaidPriceEqualTo(BigDecimal value) {
            addCriterion("directmailgoodsorderincrementdata.NewPaidPrice =", value, "newPaidPrice");
            return (Criteria) this;
        }

        public Criteria andNewPaidPriceEqualToColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.NewPaidPrice = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNewPaidPriceNotEqualTo(BigDecimal value) {
            addCriterion("directmailgoodsorderincrementdata.NewPaidPrice <>", value, "newPaidPrice");
            return (Criteria) this;
        }

        public Criteria andNewPaidPriceNotEqualToColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.NewPaidPrice <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNewPaidPriceGreaterThan(BigDecimal value) {
            addCriterion("directmailgoodsorderincrementdata.NewPaidPrice >", value, "newPaidPrice");
            return (Criteria) this;
        }

        public Criteria andNewPaidPriceGreaterThanColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.NewPaidPrice > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNewPaidPriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("directmailgoodsorderincrementdata.NewPaidPrice >=", value, "newPaidPrice");
            return (Criteria) this;
        }

        public Criteria andNewPaidPriceGreaterThanOrEqualToColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.NewPaidPrice >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNewPaidPriceLessThan(BigDecimal value) {
            addCriterion("directmailgoodsorderincrementdata.NewPaidPrice <", value, "newPaidPrice");
            return (Criteria) this;
        }

        public Criteria andNewPaidPriceLessThanColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.NewPaidPrice < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNewPaidPriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("directmailgoodsorderincrementdata.NewPaidPrice <=", value, "newPaidPrice");
            return (Criteria) this;
        }

        public Criteria andNewPaidPriceLessThanOrEqualToColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.NewPaidPrice <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNewPaidPriceIn(List<BigDecimal> values) {
            addCriterion("directmailgoodsorderincrementdata.NewPaidPrice in", values, "newPaidPrice");
            return (Criteria) this;
        }

        public Criteria andNewPaidPriceNotIn(List<BigDecimal> values) {
            addCriterion("directmailgoodsorderincrementdata.NewPaidPrice not in", values, "newPaidPrice");
            return (Criteria) this;
        }

        public Criteria andNewPaidPriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("directmailgoodsorderincrementdata.NewPaidPrice between", value1, value2, "newPaidPrice");
            return (Criteria) this;
        }

        public Criteria andNewPaidPriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("directmailgoodsorderincrementdata.NewPaidPrice not between", value1, value2, "newPaidPrice");
            return (Criteria) this;
        }

        public Criteria andNewConfirmPriceIsNull() {
            addCriterion("directmailgoodsorderincrementdata.NewConfirmPrice is null");
            return (Criteria) this;
        }

        public Criteria andNewConfirmPriceIsNotNull() {
            addCriterion("directmailgoodsorderincrementdata.NewConfirmPrice is not null");
            return (Criteria) this;
        }

        public Criteria andNewConfirmPriceEqualTo(BigDecimal value) {
            addCriterion("directmailgoodsorderincrementdata.NewConfirmPrice =", value, "newConfirmPrice");
            return (Criteria) this;
        }

        public Criteria andNewConfirmPriceEqualToColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.NewConfirmPrice = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNewConfirmPriceNotEqualTo(BigDecimal value) {
            addCriterion("directmailgoodsorderincrementdata.NewConfirmPrice <>", value, "newConfirmPrice");
            return (Criteria) this;
        }

        public Criteria andNewConfirmPriceNotEqualToColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.NewConfirmPrice <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNewConfirmPriceGreaterThan(BigDecimal value) {
            addCriterion("directmailgoodsorderincrementdata.NewConfirmPrice >", value, "newConfirmPrice");
            return (Criteria) this;
        }

        public Criteria andNewConfirmPriceGreaterThanColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.NewConfirmPrice > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNewConfirmPriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("directmailgoodsorderincrementdata.NewConfirmPrice >=", value, "newConfirmPrice");
            return (Criteria) this;
        }

        public Criteria andNewConfirmPriceGreaterThanOrEqualToColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.NewConfirmPrice >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNewConfirmPriceLessThan(BigDecimal value) {
            addCriterion("directmailgoodsorderincrementdata.NewConfirmPrice <", value, "newConfirmPrice");
            return (Criteria) this;
        }

        public Criteria andNewConfirmPriceLessThanColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.NewConfirmPrice < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNewConfirmPriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("directmailgoodsorderincrementdata.NewConfirmPrice <=", value, "newConfirmPrice");
            return (Criteria) this;
        }

        public Criteria andNewConfirmPriceLessThanOrEqualToColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.NewConfirmPrice <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNewConfirmPriceIn(List<BigDecimal> values) {
            addCriterion("directmailgoodsorderincrementdata.NewConfirmPrice in", values, "newConfirmPrice");
            return (Criteria) this;
        }

        public Criteria andNewConfirmPriceNotIn(List<BigDecimal> values) {
            addCriterion("directmailgoodsorderincrementdata.NewConfirmPrice not in", values, "newConfirmPrice");
            return (Criteria) this;
        }

        public Criteria andNewConfirmPriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("directmailgoodsorderincrementdata.NewConfirmPrice between", value1, value2, "newConfirmPrice");
            return (Criteria) this;
        }

        public Criteria andNewConfirmPriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("directmailgoodsorderincrementdata.NewConfirmPrice not between", value1, value2, "newConfirmPrice");
            return (Criteria) this;
        }

        public Criteria andNewAfterSalesPriceIsNull() {
            addCriterion("directmailgoodsorderincrementdata.NewAfterSalesPrice is null");
            return (Criteria) this;
        }

        public Criteria andNewAfterSalesPriceIsNotNull() {
            addCriterion("directmailgoodsorderincrementdata.NewAfterSalesPrice is not null");
            return (Criteria) this;
        }

        public Criteria andNewAfterSalesPriceEqualTo(BigDecimal value) {
            addCriterion("directmailgoodsorderincrementdata.NewAfterSalesPrice =", value, "newAfterSalesPrice");
            return (Criteria) this;
        }

        public Criteria andNewAfterSalesPriceEqualToColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.NewAfterSalesPrice = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNewAfterSalesPriceNotEqualTo(BigDecimal value) {
            addCriterion("directmailgoodsorderincrementdata.NewAfterSalesPrice <>", value, "newAfterSalesPrice");
            return (Criteria) this;
        }

        public Criteria andNewAfterSalesPriceNotEqualToColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.NewAfterSalesPrice <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNewAfterSalesPriceGreaterThan(BigDecimal value) {
            addCriterion("directmailgoodsorderincrementdata.NewAfterSalesPrice >", value, "newAfterSalesPrice");
            return (Criteria) this;
        }

        public Criteria andNewAfterSalesPriceGreaterThanColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.NewAfterSalesPrice > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNewAfterSalesPriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("directmailgoodsorderincrementdata.NewAfterSalesPrice >=", value, "newAfterSalesPrice");
            return (Criteria) this;
        }

        public Criteria andNewAfterSalesPriceGreaterThanOrEqualToColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.NewAfterSalesPrice >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNewAfterSalesPriceLessThan(BigDecimal value) {
            addCriterion("directmailgoodsorderincrementdata.NewAfterSalesPrice <", value, "newAfterSalesPrice");
            return (Criteria) this;
        }

        public Criteria andNewAfterSalesPriceLessThanColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.NewAfterSalesPrice < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNewAfterSalesPriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("directmailgoodsorderincrementdata.NewAfterSalesPrice <=", value, "newAfterSalesPrice");
            return (Criteria) this;
        }

        public Criteria andNewAfterSalesPriceLessThanOrEqualToColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.NewAfterSalesPrice <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNewAfterSalesPriceIn(List<BigDecimal> values) {
            addCriterion("directmailgoodsorderincrementdata.NewAfterSalesPrice in", values, "newAfterSalesPrice");
            return (Criteria) this;
        }

        public Criteria andNewAfterSalesPriceNotIn(List<BigDecimal> values) {
            addCriterion("directmailgoodsorderincrementdata.NewAfterSalesPrice not in", values, "newAfterSalesPrice");
            return (Criteria) this;
        }

        public Criteria andNewAfterSalesPriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("directmailgoodsorderincrementdata.NewAfterSalesPrice between", value1, value2, "newAfterSalesPrice");
            return (Criteria) this;
        }

        public Criteria andNewAfterSalesPriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("directmailgoodsorderincrementdata.NewAfterSalesPrice not between", value1, value2, "newAfterSalesPrice");
            return (Criteria) this;
        }

        public Criteria andNewClosePriceIsNull() {
            addCriterion("directmailgoodsorderincrementdata.NewClosePrice is null");
            return (Criteria) this;
        }

        public Criteria andNewClosePriceIsNotNull() {
            addCriterion("directmailgoodsorderincrementdata.NewClosePrice is not null");
            return (Criteria) this;
        }

        public Criteria andNewClosePriceEqualTo(BigDecimal value) {
            addCriterion("directmailgoodsorderincrementdata.NewClosePrice =", value, "newClosePrice");
            return (Criteria) this;
        }

        public Criteria andNewClosePriceEqualToColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.NewClosePrice = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNewClosePriceNotEqualTo(BigDecimal value) {
            addCriterion("directmailgoodsorderincrementdata.NewClosePrice <>", value, "newClosePrice");
            return (Criteria) this;
        }

        public Criteria andNewClosePriceNotEqualToColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.NewClosePrice <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNewClosePriceGreaterThan(BigDecimal value) {
            addCriterion("directmailgoodsorderincrementdata.NewClosePrice >", value, "newClosePrice");
            return (Criteria) this;
        }

        public Criteria andNewClosePriceGreaterThanColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.NewClosePrice > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNewClosePriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("directmailgoodsorderincrementdata.NewClosePrice >=", value, "newClosePrice");
            return (Criteria) this;
        }

        public Criteria andNewClosePriceGreaterThanOrEqualToColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.NewClosePrice >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNewClosePriceLessThan(BigDecimal value) {
            addCriterion("directmailgoodsorderincrementdata.NewClosePrice <", value, "newClosePrice");
            return (Criteria) this;
        }

        public Criteria andNewClosePriceLessThanColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.NewClosePrice < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNewClosePriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("directmailgoodsorderincrementdata.NewClosePrice <=", value, "newClosePrice");
            return (Criteria) this;
        }

        public Criteria andNewClosePriceLessThanOrEqualToColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.NewClosePrice <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNewClosePriceIn(List<BigDecimal> values) {
            addCriterion("directmailgoodsorderincrementdata.NewClosePrice in", values, "newClosePrice");
            return (Criteria) this;
        }

        public Criteria andNewClosePriceNotIn(List<BigDecimal> values) {
            addCriterion("directmailgoodsorderincrementdata.NewClosePrice not in", values, "newClosePrice");
            return (Criteria) this;
        }

        public Criteria andNewClosePriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("directmailgoodsorderincrementdata.NewClosePrice between", value1, value2, "newClosePrice");
            return (Criteria) this;
        }

        public Criteria andNewClosePriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("directmailgoodsorderincrementdata.NewClosePrice not between", value1, value2, "newClosePrice");
            return (Criteria) this;
        }

        public Criteria andNewSuccessPriceIsNull() {
            addCriterion("directmailgoodsorderincrementdata.NewSuccessPrice is null");
            return (Criteria) this;
        }

        public Criteria andNewSuccessPriceIsNotNull() {
            addCriterion("directmailgoodsorderincrementdata.NewSuccessPrice is not null");
            return (Criteria) this;
        }

        public Criteria andNewSuccessPriceEqualTo(BigDecimal value) {
            addCriterion("directmailgoodsorderincrementdata.NewSuccessPrice =", value, "newSuccessPrice");
            return (Criteria) this;
        }

        public Criteria andNewSuccessPriceEqualToColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.NewSuccessPrice = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNewSuccessPriceNotEqualTo(BigDecimal value) {
            addCriterion("directmailgoodsorderincrementdata.NewSuccessPrice <>", value, "newSuccessPrice");
            return (Criteria) this;
        }

        public Criteria andNewSuccessPriceNotEqualToColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.NewSuccessPrice <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNewSuccessPriceGreaterThan(BigDecimal value) {
            addCriterion("directmailgoodsorderincrementdata.NewSuccessPrice >", value, "newSuccessPrice");
            return (Criteria) this;
        }

        public Criteria andNewSuccessPriceGreaterThanColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.NewSuccessPrice > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNewSuccessPriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("directmailgoodsorderincrementdata.NewSuccessPrice >=", value, "newSuccessPrice");
            return (Criteria) this;
        }

        public Criteria andNewSuccessPriceGreaterThanOrEqualToColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.NewSuccessPrice >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNewSuccessPriceLessThan(BigDecimal value) {
            addCriterion("directmailgoodsorderincrementdata.NewSuccessPrice <", value, "newSuccessPrice");
            return (Criteria) this;
        }

        public Criteria andNewSuccessPriceLessThanColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.NewSuccessPrice < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNewSuccessPriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("directmailgoodsorderincrementdata.NewSuccessPrice <=", value, "newSuccessPrice");
            return (Criteria) this;
        }

        public Criteria andNewSuccessPriceLessThanOrEqualToColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.NewSuccessPrice <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNewSuccessPriceIn(List<BigDecimal> values) {
            addCriterion("directmailgoodsorderincrementdata.NewSuccessPrice in", values, "newSuccessPrice");
            return (Criteria) this;
        }

        public Criteria andNewSuccessPriceNotIn(List<BigDecimal> values) {
            addCriterion("directmailgoodsorderincrementdata.NewSuccessPrice not in", values, "newSuccessPrice");
            return (Criteria) this;
        }

        public Criteria andNewSuccessPriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("directmailgoodsorderincrementdata.NewSuccessPrice between", value1, value2, "newSuccessPrice");
            return (Criteria) this;
        }

        public Criteria andNewSuccessPriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("directmailgoodsorderincrementdata.NewSuccessPrice not between", value1, value2, "newSuccessPrice");
            return (Criteria) this;
        }

        public Criteria andNewAvgSuccessPriceIsNull() {
            addCriterion("directmailgoodsorderincrementdata.NewAvgSuccessPrice is null");
            return (Criteria) this;
        }

        public Criteria andNewAvgSuccessPriceIsNotNull() {
            addCriterion("directmailgoodsorderincrementdata.NewAvgSuccessPrice is not null");
            return (Criteria) this;
        }

        public Criteria andNewAvgSuccessPriceEqualTo(BigDecimal value) {
            addCriterion("directmailgoodsorderincrementdata.NewAvgSuccessPrice =", value, "newAvgSuccessPrice");
            return (Criteria) this;
        }

        public Criteria andNewAvgSuccessPriceEqualToColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.NewAvgSuccessPrice = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNewAvgSuccessPriceNotEqualTo(BigDecimal value) {
            addCriterion("directmailgoodsorderincrementdata.NewAvgSuccessPrice <>", value, "newAvgSuccessPrice");
            return (Criteria) this;
        }

        public Criteria andNewAvgSuccessPriceNotEqualToColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.NewAvgSuccessPrice <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNewAvgSuccessPriceGreaterThan(BigDecimal value) {
            addCriterion("directmailgoodsorderincrementdata.NewAvgSuccessPrice >", value, "newAvgSuccessPrice");
            return (Criteria) this;
        }

        public Criteria andNewAvgSuccessPriceGreaterThanColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.NewAvgSuccessPrice > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNewAvgSuccessPriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("directmailgoodsorderincrementdata.NewAvgSuccessPrice >=", value, "newAvgSuccessPrice");
            return (Criteria) this;
        }

        public Criteria andNewAvgSuccessPriceGreaterThanOrEqualToColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.NewAvgSuccessPrice >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNewAvgSuccessPriceLessThan(BigDecimal value) {
            addCriterion("directmailgoodsorderincrementdata.NewAvgSuccessPrice <", value, "newAvgSuccessPrice");
            return (Criteria) this;
        }

        public Criteria andNewAvgSuccessPriceLessThanColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.NewAvgSuccessPrice < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNewAvgSuccessPriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("directmailgoodsorderincrementdata.NewAvgSuccessPrice <=", value, "newAvgSuccessPrice");
            return (Criteria) this;
        }

        public Criteria andNewAvgSuccessPriceLessThanOrEqualToColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.NewAvgSuccessPrice <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNewAvgSuccessPriceIn(List<BigDecimal> values) {
            addCriterion("directmailgoodsorderincrementdata.NewAvgSuccessPrice in", values, "newAvgSuccessPrice");
            return (Criteria) this;
        }

        public Criteria andNewAvgSuccessPriceNotIn(List<BigDecimal> values) {
            addCriterion("directmailgoodsorderincrementdata.NewAvgSuccessPrice not in", values, "newAvgSuccessPrice");
            return (Criteria) this;
        }

        public Criteria andNewAvgSuccessPriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("directmailgoodsorderincrementdata.NewAvgSuccessPrice between", value1, value2, "newAvgSuccessPrice");
            return (Criteria) this;
        }

        public Criteria andNewAvgSuccessPriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("directmailgoodsorderincrementdata.NewAvgSuccessPrice not between", value1, value2, "newAvgSuccessPrice");
            return (Criteria) this;
        }

        public Criteria andNewPaidUserNumberIsNull() {
            addCriterion("directmailgoodsorderincrementdata.NewPaidUserNumber is null");
            return (Criteria) this;
        }

        public Criteria andNewPaidUserNumberIsNotNull() {
            addCriterion("directmailgoodsorderincrementdata.NewPaidUserNumber is not null");
            return (Criteria) this;
        }

        public Criteria andNewPaidUserNumberEqualTo(Integer value) {
            addCriterion("directmailgoodsorderincrementdata.NewPaidUserNumber =", value, "newPaidUserNumber");
            return (Criteria) this;
        }

        public Criteria andNewPaidUserNumberEqualToColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.NewPaidUserNumber = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNewPaidUserNumberNotEqualTo(Integer value) {
            addCriterion("directmailgoodsorderincrementdata.NewPaidUserNumber <>", value, "newPaidUserNumber");
            return (Criteria) this;
        }

        public Criteria andNewPaidUserNumberNotEqualToColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.NewPaidUserNumber <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNewPaidUserNumberGreaterThan(Integer value) {
            addCriterion("directmailgoodsorderincrementdata.NewPaidUserNumber >", value, "newPaidUserNumber");
            return (Criteria) this;
        }

        public Criteria andNewPaidUserNumberGreaterThanColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.NewPaidUserNumber > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNewPaidUserNumberGreaterThanOrEqualTo(Integer value) {
            addCriterion("directmailgoodsorderincrementdata.NewPaidUserNumber >=", value, "newPaidUserNumber");
            return (Criteria) this;
        }

        public Criteria andNewPaidUserNumberGreaterThanOrEqualToColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.NewPaidUserNumber >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNewPaidUserNumberLessThan(Integer value) {
            addCriterion("directmailgoodsorderincrementdata.NewPaidUserNumber <", value, "newPaidUserNumber");
            return (Criteria) this;
        }

        public Criteria andNewPaidUserNumberLessThanColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.NewPaidUserNumber < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNewPaidUserNumberLessThanOrEqualTo(Integer value) {
            addCriterion("directmailgoodsorderincrementdata.NewPaidUserNumber <=", value, "newPaidUserNumber");
            return (Criteria) this;
        }

        public Criteria andNewPaidUserNumberLessThanOrEqualToColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.NewPaidUserNumber <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNewPaidUserNumberIn(List<Integer> values) {
            addCriterion("directmailgoodsorderincrementdata.NewPaidUserNumber in", values, "newPaidUserNumber");
            return (Criteria) this;
        }

        public Criteria andNewPaidUserNumberNotIn(List<Integer> values) {
            addCriterion("directmailgoodsorderincrementdata.NewPaidUserNumber not in", values, "newPaidUserNumber");
            return (Criteria) this;
        }

        public Criteria andNewPaidUserNumberBetween(Integer value1, Integer value2) {
            addCriterion("directmailgoodsorderincrementdata.NewPaidUserNumber between", value1, value2, "newPaidUserNumber");
            return (Criteria) this;
        }

        public Criteria andNewPaidUserNumberNotBetween(Integer value1, Integer value2) {
            addCriterion("directmailgoodsorderincrementdata.NewPaidUserNumber not between", value1, value2, "newPaidUserNumber");
            return (Criteria) this;
        }

        public Criteria andNewConfirmUserNumberIsNull() {
            addCriterion("directmailgoodsorderincrementdata.NewConfirmUserNumber is null");
            return (Criteria) this;
        }

        public Criteria andNewConfirmUserNumberIsNotNull() {
            addCriterion("directmailgoodsorderincrementdata.NewConfirmUserNumber is not null");
            return (Criteria) this;
        }

        public Criteria andNewConfirmUserNumberEqualTo(Integer value) {
            addCriterion("directmailgoodsorderincrementdata.NewConfirmUserNumber =", value, "newConfirmUserNumber");
            return (Criteria) this;
        }

        public Criteria andNewConfirmUserNumberEqualToColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.NewConfirmUserNumber = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNewConfirmUserNumberNotEqualTo(Integer value) {
            addCriterion("directmailgoodsorderincrementdata.NewConfirmUserNumber <>", value, "newConfirmUserNumber");
            return (Criteria) this;
        }

        public Criteria andNewConfirmUserNumberNotEqualToColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.NewConfirmUserNumber <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNewConfirmUserNumberGreaterThan(Integer value) {
            addCriterion("directmailgoodsorderincrementdata.NewConfirmUserNumber >", value, "newConfirmUserNumber");
            return (Criteria) this;
        }

        public Criteria andNewConfirmUserNumberGreaterThanColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.NewConfirmUserNumber > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNewConfirmUserNumberGreaterThanOrEqualTo(Integer value) {
            addCriterion("directmailgoodsorderincrementdata.NewConfirmUserNumber >=", value, "newConfirmUserNumber");
            return (Criteria) this;
        }

        public Criteria andNewConfirmUserNumberGreaterThanOrEqualToColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.NewConfirmUserNumber >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNewConfirmUserNumberLessThan(Integer value) {
            addCriterion("directmailgoodsorderincrementdata.NewConfirmUserNumber <", value, "newConfirmUserNumber");
            return (Criteria) this;
        }

        public Criteria andNewConfirmUserNumberLessThanColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.NewConfirmUserNumber < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNewConfirmUserNumberLessThanOrEqualTo(Integer value) {
            addCriterion("directmailgoodsorderincrementdata.NewConfirmUserNumber <=", value, "newConfirmUserNumber");
            return (Criteria) this;
        }

        public Criteria andNewConfirmUserNumberLessThanOrEqualToColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.NewConfirmUserNumber <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNewConfirmUserNumberIn(List<Integer> values) {
            addCriterion("directmailgoodsorderincrementdata.NewConfirmUserNumber in", values, "newConfirmUserNumber");
            return (Criteria) this;
        }

        public Criteria andNewConfirmUserNumberNotIn(List<Integer> values) {
            addCriterion("directmailgoodsorderincrementdata.NewConfirmUserNumber not in", values, "newConfirmUserNumber");
            return (Criteria) this;
        }

        public Criteria andNewConfirmUserNumberBetween(Integer value1, Integer value2) {
            addCriterion("directmailgoodsorderincrementdata.NewConfirmUserNumber between", value1, value2, "newConfirmUserNumber");
            return (Criteria) this;
        }

        public Criteria andNewConfirmUserNumberNotBetween(Integer value1, Integer value2) {
            addCriterion("directmailgoodsorderincrementdata.NewConfirmUserNumber not between", value1, value2, "newConfirmUserNumber");
            return (Criteria) this;
        }

        public Criteria andNewSuccessUserNumberIsNull() {
            addCriterion("directmailgoodsorderincrementdata.NewSuccessUserNumber is null");
            return (Criteria) this;
        }

        public Criteria andNewSuccessUserNumberIsNotNull() {
            addCriterion("directmailgoodsorderincrementdata.NewSuccessUserNumber is not null");
            return (Criteria) this;
        }

        public Criteria andNewSuccessUserNumberEqualTo(Integer value) {
            addCriterion("directmailgoodsorderincrementdata.NewSuccessUserNumber =", value, "newSuccessUserNumber");
            return (Criteria) this;
        }

        public Criteria andNewSuccessUserNumberEqualToColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.NewSuccessUserNumber = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNewSuccessUserNumberNotEqualTo(Integer value) {
            addCriterion("directmailgoodsorderincrementdata.NewSuccessUserNumber <>", value, "newSuccessUserNumber");
            return (Criteria) this;
        }

        public Criteria andNewSuccessUserNumberNotEqualToColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.NewSuccessUserNumber <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNewSuccessUserNumberGreaterThan(Integer value) {
            addCriterion("directmailgoodsorderincrementdata.NewSuccessUserNumber >", value, "newSuccessUserNumber");
            return (Criteria) this;
        }

        public Criteria andNewSuccessUserNumberGreaterThanColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.NewSuccessUserNumber > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNewSuccessUserNumberGreaterThanOrEqualTo(Integer value) {
            addCriterion("directmailgoodsorderincrementdata.NewSuccessUserNumber >=", value, "newSuccessUserNumber");
            return (Criteria) this;
        }

        public Criteria andNewSuccessUserNumberGreaterThanOrEqualToColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.NewSuccessUserNumber >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNewSuccessUserNumberLessThan(Integer value) {
            addCriterion("directmailgoodsorderincrementdata.NewSuccessUserNumber <", value, "newSuccessUserNumber");
            return (Criteria) this;
        }

        public Criteria andNewSuccessUserNumberLessThanColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.NewSuccessUserNumber < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNewSuccessUserNumberLessThanOrEqualTo(Integer value) {
            addCriterion("directmailgoodsorderincrementdata.NewSuccessUserNumber <=", value, "newSuccessUserNumber");
            return (Criteria) this;
        }

        public Criteria andNewSuccessUserNumberLessThanOrEqualToColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.NewSuccessUserNumber <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNewSuccessUserNumberIn(List<Integer> values) {
            addCriterion("directmailgoodsorderincrementdata.NewSuccessUserNumber in", values, "newSuccessUserNumber");
            return (Criteria) this;
        }

        public Criteria andNewSuccessUserNumberNotIn(List<Integer> values) {
            addCriterion("directmailgoodsorderincrementdata.NewSuccessUserNumber not in", values, "newSuccessUserNumber");
            return (Criteria) this;
        }

        public Criteria andNewSuccessUserNumberBetween(Integer value1, Integer value2) {
            addCriterion("directmailgoodsorderincrementdata.NewSuccessUserNumber between", value1, value2, "newSuccessUserNumber");
            return (Criteria) this;
        }

        public Criteria andNewSuccessUserNumberNotBetween(Integer value1, Integer value2) {
            addCriterion("directmailgoodsorderincrementdata.NewSuccessUserNumber not between", value1, value2, "newSuccessUserNumber");
            return (Criteria) this;
        }

        public Criteria andNewAvgCustomerPriceIsNull() {
            addCriterion("directmailgoodsorderincrementdata.NewAvgCustomerPrice is null");
            return (Criteria) this;
        }

        public Criteria andNewAvgCustomerPriceIsNotNull() {
            addCriterion("directmailgoodsorderincrementdata.NewAvgCustomerPrice is not null");
            return (Criteria) this;
        }

        public Criteria andNewAvgCustomerPriceEqualTo(BigDecimal value) {
            addCriterion("directmailgoodsorderincrementdata.NewAvgCustomerPrice =", value, "newAvgCustomerPrice");
            return (Criteria) this;
        }

        public Criteria andNewAvgCustomerPriceEqualToColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.NewAvgCustomerPrice = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNewAvgCustomerPriceNotEqualTo(BigDecimal value) {
            addCriterion("directmailgoodsorderincrementdata.NewAvgCustomerPrice <>", value, "newAvgCustomerPrice");
            return (Criteria) this;
        }

        public Criteria andNewAvgCustomerPriceNotEqualToColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.NewAvgCustomerPrice <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNewAvgCustomerPriceGreaterThan(BigDecimal value) {
            addCriterion("directmailgoodsorderincrementdata.NewAvgCustomerPrice >", value, "newAvgCustomerPrice");
            return (Criteria) this;
        }

        public Criteria andNewAvgCustomerPriceGreaterThanColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.NewAvgCustomerPrice > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNewAvgCustomerPriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("directmailgoodsorderincrementdata.NewAvgCustomerPrice >=", value, "newAvgCustomerPrice");
            return (Criteria) this;
        }

        public Criteria andNewAvgCustomerPriceGreaterThanOrEqualToColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.NewAvgCustomerPrice >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNewAvgCustomerPriceLessThan(BigDecimal value) {
            addCriterion("directmailgoodsorderincrementdata.NewAvgCustomerPrice <", value, "newAvgCustomerPrice");
            return (Criteria) this;
        }

        public Criteria andNewAvgCustomerPriceLessThanColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.NewAvgCustomerPrice < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNewAvgCustomerPriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("directmailgoodsorderincrementdata.NewAvgCustomerPrice <=", value, "newAvgCustomerPrice");
            return (Criteria) this;
        }

        public Criteria andNewAvgCustomerPriceLessThanOrEqualToColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.NewAvgCustomerPrice <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNewAvgCustomerPriceIn(List<BigDecimal> values) {
            addCriterion("directmailgoodsorderincrementdata.NewAvgCustomerPrice in", values, "newAvgCustomerPrice");
            return (Criteria) this;
        }

        public Criteria andNewAvgCustomerPriceNotIn(List<BigDecimal> values) {
            addCriterion("directmailgoodsorderincrementdata.NewAvgCustomerPrice not in", values, "newAvgCustomerPrice");
            return (Criteria) this;
        }

        public Criteria andNewAvgCustomerPriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("directmailgoodsorderincrementdata.NewAvgCustomerPrice between", value1, value2, "newAvgCustomerPrice");
            return (Criteria) this;
        }

        public Criteria andNewAvgCustomerPriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("directmailgoodsorderincrementdata.NewAvgCustomerPrice not between", value1, value2, "newAvgCustomerPrice");
            return (Criteria) this;
        }

        public Criteria andNewSuccessPercentIsNull() {
            addCriterion("directmailgoodsorderincrementdata.NewSuccessPercent is null");
            return (Criteria) this;
        }

        public Criteria andNewSuccessPercentIsNotNull() {
            addCriterion("directmailgoodsorderincrementdata.NewSuccessPercent is not null");
            return (Criteria) this;
        }

        public Criteria andNewSuccessPercentEqualTo(String value) {
            addCriterion("directmailgoodsorderincrementdata.NewSuccessPercent =", value, "newSuccessPercent");
            return (Criteria) this;
        }

        public Criteria andNewSuccessPercentEqualToColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.NewSuccessPercent = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNewSuccessPercentNotEqualTo(String value) {
            addCriterion("directmailgoodsorderincrementdata.NewSuccessPercent <>", value, "newSuccessPercent");
            return (Criteria) this;
        }

        public Criteria andNewSuccessPercentNotEqualToColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.NewSuccessPercent <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNewSuccessPercentGreaterThan(String value) {
            addCriterion("directmailgoodsorderincrementdata.NewSuccessPercent >", value, "newSuccessPercent");
            return (Criteria) this;
        }

        public Criteria andNewSuccessPercentGreaterThanColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.NewSuccessPercent > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNewSuccessPercentGreaterThanOrEqualTo(String value) {
            addCriterion("directmailgoodsorderincrementdata.NewSuccessPercent >=", value, "newSuccessPercent");
            return (Criteria) this;
        }

        public Criteria andNewSuccessPercentGreaterThanOrEqualToColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.NewSuccessPercent >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNewSuccessPercentLessThan(String value) {
            addCriterion("directmailgoodsorderincrementdata.NewSuccessPercent <", value, "newSuccessPercent");
            return (Criteria) this;
        }

        public Criteria andNewSuccessPercentLessThanColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.NewSuccessPercent < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNewSuccessPercentLessThanOrEqualTo(String value) {
            addCriterion("directmailgoodsorderincrementdata.NewSuccessPercent <=", value, "newSuccessPercent");
            return (Criteria) this;
        }

        public Criteria andNewSuccessPercentLessThanOrEqualToColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.NewSuccessPercent <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNewSuccessPercentLike(String value) {
            addCriterion("directmailgoodsorderincrementdata.NewSuccessPercent like", value, "newSuccessPercent");
            return (Criteria) this;
        }

        public Criteria andNewSuccessPercentNotLike(String value) {
            addCriterion("directmailgoodsorderincrementdata.NewSuccessPercent not like", value, "newSuccessPercent");
            return (Criteria) this;
        }

        public Criteria andNewSuccessPercentIn(List<String> values) {
            addCriterion("directmailgoodsorderincrementdata.NewSuccessPercent in", values, "newSuccessPercent");
            return (Criteria) this;
        }

        public Criteria andNewSuccessPercentNotIn(List<String> values) {
            addCriterion("directmailgoodsorderincrementdata.NewSuccessPercent not in", values, "newSuccessPercent");
            return (Criteria) this;
        }

        public Criteria andNewSuccessPercentBetween(String value1, String value2) {
            addCriterion("directmailgoodsorderincrementdata.NewSuccessPercent between", value1, value2, "newSuccessPercent");
            return (Criteria) this;
        }

        public Criteria andNewSuccessPercentNotBetween(String value1, String value2) {
            addCriterion("directmailgoodsorderincrementdata.NewSuccessPercent not between", value1, value2, "newSuccessPercent");
            return (Criteria) this;
        }

        public Criteria andRecordTimeIsNull() {
            addCriterion("directmailgoodsorderincrementdata.RecordTime is null");
            return (Criteria) this;
        }

        public Criteria andRecordTimeIsNotNull() {
            addCriterion("directmailgoodsorderincrementdata.RecordTime is not null");
            return (Criteria) this;
        }

        public Criteria andRecordTimeEqualTo(Date value) {
            addCriterion("directmailgoodsorderincrementdata.RecordTime =", value, "recordTime");
            return (Criteria) this;
        }

        public Criteria andRecordTimeEqualToColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.RecordTime = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andRecordTimeNotEqualTo(Date value) {
            addCriterion("directmailgoodsorderincrementdata.RecordTime <>", value, "recordTime");
            return (Criteria) this;
        }

        public Criteria andRecordTimeNotEqualToColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.RecordTime <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andRecordTimeGreaterThan(Date value) {
            addCriterion("directmailgoodsorderincrementdata.RecordTime >", value, "recordTime");
            return (Criteria) this;
        }

        public Criteria andRecordTimeGreaterThanColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.RecordTime > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andRecordTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("directmailgoodsorderincrementdata.RecordTime >=", value, "recordTime");
            return (Criteria) this;
        }

        public Criteria andRecordTimeGreaterThanOrEqualToColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.RecordTime >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andRecordTimeLessThan(Date value) {
            addCriterion("directmailgoodsorderincrementdata.RecordTime <", value, "recordTime");
            return (Criteria) this;
        }

        public Criteria andRecordTimeLessThanColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.RecordTime < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andRecordTimeLessThanOrEqualTo(Date value) {
            addCriterion("directmailgoodsorderincrementdata.RecordTime <=", value, "recordTime");
            return (Criteria) this;
        }

        public Criteria andRecordTimeLessThanOrEqualToColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.RecordTime <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andRecordTimeIn(List<Date> values) {
            addCriterion("directmailgoodsorderincrementdata.RecordTime in", values, "recordTime");
            return (Criteria) this;
        }

        public Criteria andRecordTimeNotIn(List<Date> values) {
            addCriterion("directmailgoodsorderincrementdata.RecordTime not in", values, "recordTime");
            return (Criteria) this;
        }

        public Criteria andRecordTimeBetween(Date value1, Date value2) {
            addCriterion("directmailgoodsorderincrementdata.RecordTime between", value1, value2, "recordTime");
            return (Criteria) this;
        }

        public Criteria andRecordTimeNotBetween(Date value1, Date value2) {
            addCriterion("directmailgoodsorderincrementdata.RecordTime not between", value1, value2, "recordTime");
            return (Criteria) this;
        }

        public Criteria andDeletedIsNull() {
            addCriterion("directmailgoodsorderincrementdata.Deleted is null");
            return (Criteria) this;
        }

        public Criteria andDeletedIsNotNull() {
            addCriterion("directmailgoodsorderincrementdata.Deleted is not null");
            return (Criteria) this;
        }

        public Criteria andDeletedEqualTo(Boolean value) {
            addCriterion("directmailgoodsorderincrementdata.Deleted =", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedEqualToColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.Deleted = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDeletedNotEqualTo(Boolean value) {
            addCriterion("directmailgoodsorderincrementdata.Deleted <>", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedNotEqualToColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.Deleted <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDeletedGreaterThan(Boolean value) {
            addCriterion("directmailgoodsorderincrementdata.Deleted >", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedGreaterThanColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.Deleted > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDeletedGreaterThanOrEqualTo(Boolean value) {
            addCriterion("directmailgoodsorderincrementdata.Deleted >=", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedGreaterThanOrEqualToColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.Deleted >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDeletedLessThan(Boolean value) {
            addCriterion("directmailgoodsorderincrementdata.Deleted <", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedLessThanColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.Deleted < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDeletedLessThanOrEqualTo(Boolean value) {
            addCriterion("directmailgoodsorderincrementdata.Deleted <=", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedLessThanOrEqualToColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.Deleted <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDeletedIn(List<Boolean> values) {
            addCriterion("directmailgoodsorderincrementdata.Deleted in", values, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedNotIn(List<Boolean> values) {
            addCriterion("directmailgoodsorderincrementdata.Deleted not in", values, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedBetween(Boolean value1, Boolean value2) {
            addCriterion("directmailgoodsorderincrementdata.Deleted between", value1, value2, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedNotBetween(Boolean value1, Boolean value2) {
            addCriterion("directmailgoodsorderincrementdata.Deleted not between", value1, value2, "deleted");
            return (Criteria) this;
        }

        public Criteria andCreateUserIsNull() {
            addCriterion("directmailgoodsorderincrementdata.`CreateUser` is null");
            return (Criteria) this;
        }

        public Criteria andCreateUserIsNotNull() {
            addCriterion("directmailgoodsorderincrementdata.`CreateUser` is not null");
            return (Criteria) this;
        }

        public Criteria andCreateUserEqualTo(String value) {
            addCriterion("directmailgoodsorderincrementdata.`CreateUser` =", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserEqualToColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.`CreateUser` = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateUserNotEqualTo(String value) {
            addCriterion("directmailgoodsorderincrementdata.`CreateUser` <>", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserNotEqualToColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.`CreateUser` <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateUserGreaterThan(String value) {
            addCriterion("directmailgoodsorderincrementdata.`CreateUser` >", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserGreaterThanColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.`CreateUser` > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateUserGreaterThanOrEqualTo(String value) {
            addCriterion("directmailgoodsorderincrementdata.`CreateUser` >=", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserGreaterThanOrEqualToColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.`CreateUser` >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateUserLessThan(String value) {
            addCriterion("directmailgoodsorderincrementdata.`CreateUser` <", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserLessThanColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.`CreateUser` < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateUserLessThanOrEqualTo(String value) {
            addCriterion("directmailgoodsorderincrementdata.`CreateUser` <=", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserLessThanOrEqualToColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.`CreateUser` <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateUserLike(String value) {
            addCriterion("directmailgoodsorderincrementdata.`CreateUser` like", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserNotLike(String value) {
            addCriterion("directmailgoodsorderincrementdata.`CreateUser` not like", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserIn(List<String> values) {
            addCriterion("directmailgoodsorderincrementdata.`CreateUser` in", values, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserNotIn(List<String> values) {
            addCriterion("directmailgoodsorderincrementdata.`CreateUser` not in", values, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserBetween(String value1, String value2) {
            addCriterion("directmailgoodsorderincrementdata.`CreateUser` between", value1, value2, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserNotBetween(String value1, String value2) {
            addCriterion("directmailgoodsorderincrementdata.`CreateUser` not between", value1, value2, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNull() {
            addCriterion("directmailgoodsorderincrementdata.CreateTime is null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNotNull() {
            addCriterion("directmailgoodsorderincrementdata.CreateTime is not null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeEqualTo(Date value) {
            addCriterion("directmailgoodsorderincrementdata.CreateTime =", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeEqualToColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.CreateTime = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotEqualTo(Date value) {
            addCriterion("directmailgoodsorderincrementdata.CreateTime <>", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotEqualToColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.CreateTime <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThan(Date value) {
            addCriterion("directmailgoodsorderincrementdata.CreateTime >", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThanColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.CreateTime > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("directmailgoodsorderincrementdata.CreateTime >=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThanOrEqualToColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.CreateTime >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThan(Date value) {
            addCriterion("directmailgoodsorderincrementdata.CreateTime <", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThanColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.CreateTime < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThanOrEqualTo(Date value) {
            addCriterion("directmailgoodsorderincrementdata.CreateTime <=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThanOrEqualToColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.CreateTime <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateTimeIn(List<Date> values) {
            addCriterion("directmailgoodsorderincrementdata.CreateTime in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotIn(List<Date> values) {
            addCriterion("directmailgoodsorderincrementdata.CreateTime not in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeBetween(Date value1, Date value2) {
            addCriterion("directmailgoodsorderincrementdata.CreateTime between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotBetween(Date value1, Date value2) {
            addCriterion("directmailgoodsorderincrementdata.CreateTime not between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andUpdateUserIsNull() {
            addCriterion("directmailgoodsorderincrementdata.UpdateUser is null");
            return (Criteria) this;
        }

        public Criteria andUpdateUserIsNotNull() {
            addCriterion("directmailgoodsorderincrementdata.UpdateUser is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateUserEqualTo(String value) {
            addCriterion("directmailgoodsorderincrementdata.UpdateUser =", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserEqualToColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.UpdateUser = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotEqualTo(String value) {
            addCriterion("directmailgoodsorderincrementdata.UpdateUser <>", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotEqualToColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.UpdateUser <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateUserGreaterThan(String value) {
            addCriterion("directmailgoodsorderincrementdata.UpdateUser >", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserGreaterThanColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.UpdateUser > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateUserGreaterThanOrEqualTo(String value) {
            addCriterion("directmailgoodsorderincrementdata.UpdateUser >=", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserGreaterThanOrEqualToColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.UpdateUser >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateUserLessThan(String value) {
            addCriterion("directmailgoodsorderincrementdata.UpdateUser <", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserLessThanColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.UpdateUser < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateUserLessThanOrEqualTo(String value) {
            addCriterion("directmailgoodsorderincrementdata.UpdateUser <=", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserLessThanOrEqualToColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.UpdateUser <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateUserLike(String value) {
            addCriterion("directmailgoodsorderincrementdata.UpdateUser like", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotLike(String value) {
            addCriterion("directmailgoodsorderincrementdata.UpdateUser not like", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserIn(List<String> values) {
            addCriterion("directmailgoodsorderincrementdata.UpdateUser in", values, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotIn(List<String> values) {
            addCriterion("directmailgoodsorderincrementdata.UpdateUser not in", values, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserBetween(String value1, String value2) {
            addCriterion("directmailgoodsorderincrementdata.UpdateUser between", value1, value2, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotBetween(String value1, String value2) {
            addCriterion("directmailgoodsorderincrementdata.UpdateUser not between", value1, value2, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIsNull() {
            addCriterion("directmailgoodsorderincrementdata.UpdateTime is null");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIsNotNull() {
            addCriterion("directmailgoodsorderincrementdata.UpdateTime is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeEqualTo(Date value) {
            addCriterion("directmailgoodsorderincrementdata.UpdateTime =", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeEqualToColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.UpdateTime = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotEqualTo(Date value) {
            addCriterion("directmailgoodsorderincrementdata.UpdateTime <>", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotEqualToColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.UpdateTime <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThan(Date value) {
            addCriterion("directmailgoodsorderincrementdata.UpdateTime >", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThanColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.UpdateTime > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("directmailgoodsorderincrementdata.UpdateTime >=", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThanOrEqualToColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.UpdateTime >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThan(Date value) {
            addCriterion("directmailgoodsorderincrementdata.UpdateTime <", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThanColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.UpdateTime < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThanOrEqualTo(Date value) {
            addCriterion("directmailgoodsorderincrementdata.UpdateTime <=", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThanOrEqualToColumn(DirectMailGoodsOrderIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderincrementdata.UpdateTime <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIn(List<Date> values) {
            addCriterion("directmailgoodsorderincrementdata.UpdateTime in", values, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotIn(List<Date> values) {
            addCriterion("directmailgoodsorderincrementdata.UpdateTime not in", values, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeBetween(Date value1, Date value2) {
            addCriterion("directmailgoodsorderincrementdata.UpdateTime between", value1, value2, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotBetween(Date value1, Date value2) {
            addCriterion("directmailgoodsorderincrementdata.UpdateTime not between", value1, value2, "updateTime");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {
        private DirectMailGoodsOrderIncrementDataExample example;

        protected Criteria(DirectMailGoodsOrderIncrementDataExample example) {
            super();
            this.example = example;
        }

        public DirectMailGoodsOrderIncrementDataExample example() {
            return this.example;
        }

        @Deprecated
        public Criteria andIf(boolean ifAdd, ICriteriaAdd add) {
            if (ifAdd) {
                add.add(this);
            }
            return this;
        }

        public Criteria when(boolean condition, ICriteriaWhen then) {
            if (condition) {
                then.criteria(this);
            }
            return this;
        }

        public Criteria when(boolean condition, ICriteriaWhen then, ICriteriaWhen otherwise) {
            if (condition) {
                then.criteria(this);
            } else {
                otherwise.criteria(this);
            }
            return this;
        }

        public Criteria andLogicalDeleted(boolean deleted) {
            return deleted ? andDeletedEqualTo(DirectMailGoodsOrderIncrementData.Deleted.IS_DELETED.value()) : andDeletedNotEqualTo(DirectMailGoodsOrderIncrementData.Deleted.IS_DELETED.value());
        }

        @Deprecated
        public interface ICriteriaAdd {
            Criteria add(Criteria add);
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }

    public interface ICriteriaWhen {
        void criteria(Criteria criteria);
    }

    public interface IExampleWhen {
        void example(com.ecoolex.chinadutyfree.retailer.entity.DirectMailGoodsOrderIncrementDataExample example);
    }
}